Dataset statistics
| Number of variables | 41 |
|---|---|
| Number of observations | 1013986 |
| Missing cells | 14263504 |
| Missing cells (%) | 34.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.8 GiB |
| Average record size in memory | 1.8 KiB |
Variable types
| CAT | 20 |
|---|---|
| UNSUPPORTED | 14 |
| NUM | 7 |
Reproduction
| Analysis started | 2022-12-16 21:02:02.385646 |
|---|---|
| Analysis finished | 2022-12-16 21:06:45.275177 |
| Duration | 4 minutes and 42.89 seconds |
| Version | pandas-profiling v2.7.1 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Agency has constant value "HPD" | Constant |
Complaint Type has constant value "HEAT/HOT WATER" | Constant |
Location Type has constant value "RESIDENTIAL BUILDING" | Constant |
Park Facility Name has constant value "Unspecified" | Constant |
Created Date has a high cardinality: 981277 distinct values | High cardinality |
Closed Date has a high cardinality: 278282 distinct values | High cardinality |
Incident Address has a high cardinality: 82894 distinct values | High cardinality |
Street Name has a high cardinality: 5068 distinct values | High cardinality |
City has a high cardinality: 87 distinct values | High cardinality |
Resolution Action Updated Date has a high cardinality: 213342 distinct values | High cardinality |
Community Board has a high cardinality: 71 distinct values | High cardinality |
Location has a high cardinality: 85329 distinct values | High cardinality |
BBL is highly correlated with Incident Zip | High correlation |
Incident Zip is highly correlated with BBL | High correlation |
Latitude is highly correlated with Y Coordinate (State Plane) | High correlation |
Y Coordinate (State Plane) is highly correlated with Latitude | High correlation |
Longitude is highly correlated with X Coordinate (State Plane) | High correlation |
X Coordinate (State Plane) is highly correlated with Longitude | High correlation |
Borough is highly correlated with Community Board and 1 other fields | High correlation |
Community Board is highly correlated with Borough and 1 other fields | High correlation |
Park Borough is highly correlated with Community Board and 1 other fields | High correlation |
Cross Street 1 has 1013986 (100.0%) missing values | Missing |
Cross Street 2 has 1013986 (100.0%) missing values | Missing |
Intersection Street 1 has 1013986 (100.0%) missing values | Missing |
Intersection Street 2 has 1013986 (100.0%) missing values | Missing |
Landmark has 1013986 (100.0%) missing values | Missing |
Facility Type has 1013986 (100.0%) missing values | Missing |
Due Date has 1013986 (100.0%) missing values | Missing |
BBL has 10690 (1.1%) missing values | Missing |
Vehicle Type has 1013986 (100.0%) missing values | Missing |
Taxi Company Borough has 1013986 (100.0%) missing values | Missing |
Taxi Pick Up Location has 1013986 (100.0%) missing values | Missing |
Bridge Highway Name has 1013986 (100.0%) missing values | Missing |
Bridge Highway Direction has 1013986 (100.0%) missing values | Missing |
Road Ramp has 1013986 (100.0%) missing values | Missing |
Bridge Highway Segment has 1013986 (100.0%) missing values | Missing |
Created Date is uniformly distributed | Uniform |
Unique Key has unique values | Unique |
Cross Street 1 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Cross Street 2 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Intersection Street 1 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Intersection Street 2 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Landmark is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Facility Type is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Due Date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Vehicle Type is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Taxi Company Borough is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Taxi Pick Up Location is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Bridge Highway Name is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Bridge Highway Direction is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Road Ramp is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Bridge Highway Segment is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
| Distinct count | 1013986 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43130257.056178294 |
|---|---|
| Minimum | 35139948 |
| Maximum | 52934200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.7 MiB |
Quantile statistics
| Minimum | 35139948 |
|---|---|
| 5-th percentile | 35519600.25 |
| Q1 | 38214325.25 |
| median | 41783978.5 |
| Q3 | 48068128.75 |
| 95-th percentile | 52528982.75 |
| Maximum | 52934200 |
| Range | 17794252 |
| Interquartile range (IQR) | 9853803.5 |
Descriptive statistics
| Standard deviation | 5305137.844 |
|---|---|
| Coefficient of variation (CV) | 0.1230026948 |
| Kurtosis | -1.123085758 |
| Mean | 43130257.06 |
| Median Absolute Deviation (MAD) | 3853779.5 |
| Skewness | 0.2883078079 |
| Sum | 4.373347683e+13 |
| Variance | 2.814448754e+13 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 37748736 | 1 | < 0.1% | |
| 52800024 | 1 | < 0.1% | |
| 48587600 | 1 | < 0.1% | |
| 38122011 | 1 | < 0.1% | |
| 38111772 | 1 | < 0.1% | |
| 48298278 | 1 | < 0.1% | |
| 38113823 | 1 | < 0.1% | |
| 52718112 | 1 | < 0.1% | |
| 48521761 | 1 | < 0.1% | |
| 38923535 | 1 | < 0.1% | |
| Other values (1013976) | 1013976 | > 99.9% |
| Value | Count | Frequency (%) | |
| 35139948 | 1 | < 0.1% | |
| 35143918 | 1 | < 0.1% | |
| 35143919 | 1 | < 0.1% | |
| 35143920 | 1 | < 0.1% | |
| 35143921 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 52934200 | 1 | < 0.1% | |
| 52931496 | 1 | < 0.1% | |
| 52931495 | 1 | < 0.1% | |
| 52931494 | 1 | < 0.1% | |
| 52931482 | 1 | < 0.1% |
| Distinct count | 981277 |
|---|---|
| Unique (%) | 96.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| 01/08/2018 12:00:00 AM | 21 |
|---|---|
| 01/07/2018 12:00:00 AM | 17 |
| 11/12/2017 12:00:00 AM | 16 |
| 01/23/2017 12:00:00 AM | 16 |
| 03/14/2017 12:00:00 AM | 13 |
| Other values (981272) |
| Value | Count | Frequency (%) | |
| 01/08/2018 12:00:00 AM | 21 | < 0.1% | |
| 01/07/2018 12:00:00 AM | 17 | < 0.1% | |
| 11/12/2017 12:00:00 AM | 16 | < 0.1% | |
| 01/23/2017 12:00:00 AM | 16 | < 0.1% | |
| 03/14/2017 12:00:00 AM | 13 | < 0.1% | |
| 11/23/2018 12:00:00 AM | 13 | < 0.1% | |
| 11/10/2017 12:00:00 AM | 13 | < 0.1% | |
| 03/27/2017 12:00:00 AM | 12 | < 0.1% | |
| 03/04/2017 12:00:00 AM | 12 | < 0.1% | |
| 01/01/2018 12:00:00 AM | 12 | < 0.1% | |
| Other values (981267) | 1013841 | > 99.9% |
Length
| Max length | 22 |
|---|---|
| Mean length | 22 |
| Min length | 22 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 62.5% | |
| Uppercase_Letter | 3 | 18.8% | |
| Other_Punctuation | 2 | 12.5% | |
| Space_Separator | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| Common | 13 | 81.2% | |
| Latin | 3 | 18.8% |
| Value | Count | Frequency (%) | |
| ASCII | 16 | 100.0% |
| Distinct count | 278282 |
|---|---|
| Unique (%) | 27.5% |
| Missing | 985 |
| Missing (%) | 0.1% |
| Memory size | 7.7 MiB |
| 10/24/2018 06:56:33 PM | 293 |
|---|---|
| 11/28/2017 02:07:20 AM | 259 |
| 11/16/2017 10:09:40 AM | 244 |
| 03/28/2018 09:52:41 PM | 241 |
| 11/11/2019 06:49:35 PM | 239 |
| Other values (278277) |
| Value | Count | Frequency (%) | |
| 10/24/2018 06:56:33 PM | 293 | < 0.1% | |
| 11/28/2017 02:07:20 AM | 259 | < 0.1% | |
| 11/16/2017 10:09:40 AM | 244 | < 0.1% | |
| 03/28/2018 09:52:41 PM | 241 | < 0.1% | |
| 11/11/2019 06:49:35 PM | 239 | < 0.1% | |
| 02/20/2019 02:09:53 AM | 228 | < 0.1% | |
| 02/14/2021 06:15:27 PM | 180 | < 0.1% | |
| 10/23/2018 02:09:20 AM | 167 | < 0.1% | |
| 10/27/2018 06:43:20 PM | 162 | < 0.1% | |
| 01/29/2019 09:45:59 PM | 158 | < 0.1% | |
| Other values (278272) | 1010830 | 99.7% | |
| (Missing) | 985 | 0.1% |
Length
| Max length | 22 |
|---|---|
| Mean length | 21.98154314 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 55.6% | |
| Uppercase_Letter | 3 | 16.7% | |
| Other_Punctuation | 2 | 11.1% | |
| Lowercase_Letter | 2 | 11.1% | |
| Space_Separator | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| Common | 13 | 72.2% | |
| Latin | 5 | 27.8% |
| Value | Count | Frequency (%) | |
| ASCII | 18 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| HPD |
|---|
| Value | Count | Frequency (%) | |
| HPD | 1013986 | 100.0% |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 3 | 100.0% |
Agency Name
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| Department of Housing Preservation and Development | |
|---|---|
| Division of Alternative Management | 107 |
| Value | Count | Frequency (%) | |
| Department of Housing Preservation and Development | 1013879 | > 99.9% | |
| Division of Alternative Management | 107 | < 0.1% |
Length
| Max length | 50 |
|---|---|
| Mean length | 49.99831161 |
| Min length | 34 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 16 | 72.7% | |
| Uppercase_Letter | 5 | 22.7% | |
| Space_Separator | 1 | 4.5% |
| Value | Count | Frequency (%) | |
| Latin | 21 | 95.5% | |
| Common | 1 | 4.5% |
| Value | Count | Frequency (%) | |
| ASCII | 22 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| HEAT/HOT WATER |
|---|
| Value | Count | Frequency (%) | |
| HEAT/HOT WATER | 1013986 | 100.0% |
Length
| Max length | 14 |
|---|---|
| Mean length | 14 |
| Min length | 14 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 7 | 77.8% | |
| Other_Punctuation | 1 | 11.1% | |
| Space_Separator | 1 | 11.1% |
| Value | Count | Frequency (%) | |
| Latin | 7 | 77.8% | |
| Common | 2 | 22.2% |
| Value | Count | Frequency (%) | |
| ASCII | 9 | 100.0% |
Descriptor
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| ENTIRE BUILDING | |
|---|---|
| APARTMENT ONLY |
| Value | Count | Frequency (%) | |
| ENTIRE BUILDING | 658553 | 64.9% | |
| APARTMENT ONLY | 355433 | 35.1% |
Length
| Max length | 15 |
|---|---|
| Mean length | 14.64946952 |
| Min length | 14 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 15 | 93.8% | |
| Space_Separator | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| Latin | 15 | 93.8% | |
| Common | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| ASCII | 16 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| RESIDENTIAL BUILDING |
|---|
| Value | Count | Frequency (%) | |
| RESIDENTIAL BUILDING | 1013986 | 100.0% |
Length
| Max length | 20 |
|---|---|
| Mean length | 20 |
| Min length | 20 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 12 | 92.3% | |
| Space_Separator | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| Latin | 12 | 92.3% | |
| Common | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| ASCII | 13 | 100.0% |
| Distinct count | 190 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 7043 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10713.993183328153 |
|---|---|
| Minimum | 10001.0 |
| Maximum | 12345.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.7 MiB |
Quantile statistics
| Minimum | 10001 |
|---|---|
| 5-th percentile | 10023 |
| Q1 | 10452 |
| median | 10467 |
| Q3 | 11223 |
| 95-th percentile | 11385 |
| Maximum | 12345 |
| Range | 2344 |
| Interquartile range (IQR) | 771 |
Descriptive statistics
| Standard deviation | 513.8201629 |
|---|---|
| Coefficient of variation (CV) | 0.04795785793 |
| Kurtosis | -1.540497936 |
| Mean | 10713.99318 |
| Median Absolute Deviation (MAD) | 442 |
| Skewness | 0.03758202946 |
| Sum | 1.078838044e+10 |
| Variance | 264011.1598 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 11226 | 35469 | 3.5% | |
| 10458 | 30056 | 3.0% | |
| 10457 | 29707 | 2.9% | |
| 10467 | 29574 | 2.9% | |
| 10468 | 26945 | 2.7% | |
| 10452 | 25839 | 2.5% | |
| 10453 | 25705 | 2.5% | |
| 10462 | 22878 | 2.3% | |
| 10031 | 21526 | 2.1% | |
| 11225 | 20640 | 2.0% | |
| Other values (180) | 738604 | 72.8% |
| Value | Count | Frequency (%) | |
| 10001 | 1590 | 0.2% | |
| 10002 | 7712 | 0.8% | |
| 10003 | 5362 | 0.5% | |
| 10004 | 51 | < 0.1% | |
| 10005 | 55 | < 0.1% |
| Value | Count | Frequency (%) | |
| 12345 | 2 | < 0.1% | |
| 11697 | 8 | < 0.1% | |
| 11694 | 1847 | 0.2% | |
| 11693 | 467 | < 0.1% | |
| 11692 | 1471 | 0.1% |
| Distinct count | 82894 |
|---|---|
| Unique (%) | 8.2% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 7.7 MiB |
| 89-21 ELMHURST AVENUE | 9460 |
|---|---|
| 2176 TIEBOUT AVENUE | 8134 |
| 9511 SHORE ROAD | 4781 |
| 2040 BRONXDALE AVENUE | 3987 |
| 1711 FULTON STREET | 3165 |
| Other values (82889) |
| Value | Count | Frequency (%) | |
| 89-21 ELMHURST AVENUE | 9460 | 0.9% | |
| 2176 TIEBOUT AVENUE | 8134 | 0.8% | |
| 9511 SHORE ROAD | 4781 | 0.5% | |
| 2040 BRONXDALE AVENUE | 3987 | 0.4% | |
| 1711 FULTON STREET | 3165 | 0.3% | |
| 1425 DR M L KING JR BOULEVARD | 3066 | 0.3% | |
| 2750 HOMECREST AVENUE | 2503 | 0.2% | |
| 2664 GRAND CONCOURSE | 2463 | 0.2% | |
| 2090 EAST TREMONT AVENUE | 2337 | 0.2% | |
| 1025 BOYNTON AVENUE | 2301 | 0.2% | |
| Other values (82884) | 971786 | 95.8% |
Length
| Max length | 38 |
|---|---|
| Mean length | 18.71441618 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 26 | 61.9% | |
| Decimal_Number | 10 | 23.8% | |
| Other_Punctuation | 2 | 4.8% | |
| Lowercase_Letter | 2 | 4.8% | |
| Dash_Punctuation | 1 | 2.4% | |
| Space_Separator | 1 | 2.4% |
| Value | Count | Frequency (%) | |
| Latin | 28 | 66.7% | |
| Common | 14 | 33.3% |
| Value | Count | Frequency (%) | |
| ASCII | 42 | 100.0% |
| Distinct count | 5068 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 7.7 MiB |
| GRAND CONCOURSE | 17957 |
|---|---|
| BROADWAY | 11402 |
| TIEBOUT AVENUE | 10020 |
| ELMHURST AVENUE | 9935 |
| OCEAN AVENUE | 8495 |
| Other values (5063) |
| Value | Count | Frequency (%) | |
| GRAND CONCOURSE | 17957 | 1.8% | |
| BROADWAY | 11402 | 1.1% | |
| TIEBOUT AVENUE | 10020 | 1.0% | |
| ELMHURST AVENUE | 9935 | 1.0% | |
| OCEAN AVENUE | 8495 | 0.8% | |
| ST NICHOLAS AVENUE | 7277 | 0.7% | |
| MORRIS AVENUE | 6983 | 0.7% | |
| DR M L KING JR BOULEVARD | 6087 | 0.6% | |
| BEDFORD AVENUE | 5378 | 0.5% | |
| SHORE ROAD | 5274 | 0.5% | |
| Other values (5058) | 925175 | 91.2% |
Length
| Max length | 32 |
|---|---|
| Mean length | 14.12712503 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 26 | 63.4% | |
| Decimal_Number | 10 | 24.4% | |
| Lowercase_Letter | 2 | 4.9% | |
| Space_Separator | 1 | 2.4% | |
| Dash_Punctuation | 1 | 2.4% | |
| Other_Punctuation | 1 | 2.4% |
| Value | Count | Frequency (%) | |
| Latin | 28 | 68.3% | |
| Common | 13 | 31.7% |
| Value | Count | Frequency (%) | |
| ASCII | 41 | 100.0% |
Address Type
Categorical
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 6740 |
| Missing (%) | 0.7% |
| Memory size | 7.7 MiB |
| ADDRESS |
|---|
| Value | Count | Frequency (%) | |
| ADDRESS | 1007246 | 99.3% | |
| (Missing) | 6740 | 0.7% |
Length
| Max length | 7 |
|---|---|
| Mean length | 6.973411862 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 5 | 71.4% | |
| Lowercase_Letter | 2 | 28.6% |
| Value | Count | Frequency (%) | |
| Latin | 7 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 7 | 100.0% |
| Distinct count | 87 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 6947 |
| Missing (%) | 0.7% |
| Memory size | 7.7 MiB |
| BRONX | |
|---|---|
| BROOKLYN | |
| NEW YORK | |
| Elmhurst | 14334 |
| Jamaica | 13189 |
| Other values (82) |
| Value | Count | Frequency (%) | |
| BRONX | 337191 | 33.3% | |
| BROOKLYN | 300702 | 29.7% | |
| NEW YORK | 222864 | 22.0% | |
| Elmhurst | 14334 | 1.4% | |
| Jamaica | 13189 | 1.3% | |
| Flushing | 11947 | 1.2% | |
| Astoria | 10734 | 1.1% | |
| STATEN ISLAND | 10323 | 1.0% | |
| Ridgewood | 7621 | 0.8% | |
| Woodside | 6663 | 0.7% | |
| Other values (77) | 71471 | 7.0% | |
| (Missing) | 6947 | 0.7% |
Length
| Max length | 19 |
|---|---|
| Mean length | 7.236024955 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 26 | 52.0% | |
| Lowercase_Letter | 23 | 46.0% | |
| Space_Separator | 1 | 2.0% |
| Value | Count | Frequency (%) | |
| Latin | 49 | 98.0% | |
| Common | 1 | 2.0% |
| Value | Count | Frequency (%) | |
| ASCII | 50 | 100.0% |
Status
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| Closed | |
|---|---|
| Open | 985 |
| Value | Count | Frequency (%) | |
| Closed | 1013001 | 99.9% | |
| Open | 985 | 0.1% |
Length
| Max length | 6 |
|---|---|
| Mean length | 5.998057172 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 7 | 77.8% | |
| Uppercase_Letter | 2 | 22.2% |
| Value | Count | Frequency (%) | |
| Latin | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 9 | 100.0% |
Resolution Description
Categorical
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 65 |
| Missing (%) | < 0.1% |
| Memory size | 7.7 MiB |
| The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. | |
|---|---|
| The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint. | |
| The Department of Housing Preservation and Development was not able to gain access to your apartment or others in the building to inspect for a lack of heat or hot water. The complaint has been closed. If the condition still exists, please file a new complaint. | |
| The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option. | |
| The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed. | |
| Other values (19) |
| Value | Count | Frequency (%) | |
| The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. | 304469 | 30.0% | |
| The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint. | 241689 | 23.8% | |
| The Department of Housing Preservation and Development was not able to gain access to your apartment or others in the building to inspect for a lack of heat or hot water. The complaint has been closed. If the condition still exists, please file a new complaint. | 135538 | 13.4% | |
| The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option. | 85005 | 8.4% | |
| The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed. | 84354 | 8.3% | |
| The Department of Housing Preservation and Development contacted an occupant of the apartment and verified that the following conditions were corrected. The complaint has been closed. If the condition still exists, please file a new complaint. | 49306 | 4.9% | |
| The Department of Housing Preservation and Development contacted a tenant in the building and verified that the following conditions were corrected. The complaint has been closed. If the condition still exists, please file a new complaint. | 39723 | 3.9% | |
| The Department of Housing Preservation and Development inspected the following conditions. Violations were issued. Information about specific violations is available at www.nyc.gov/hpd. | 32453 | 3.2% | |
| The Department of Housing Preservation and Development has closed this complaint administratively. More information can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option. | 19503 | 1.9% | |
| The following complaint conditions are still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection. | 6434 | 0.6% | |
| Other values (14) | 15447 | 1.5% |
Length
| Max length | 382 |
|---|---|
| Mean length | 271.6016612 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 24 | 38.7% | |
| Uppercase_Letter | 20 | 32.3% | |
| Decimal_Number | 10 | 16.1% | |
| Other_Punctuation | 4 | 6.5% | |
| Close_Punctuation | 1 | 1.6% | |
| Open_Punctuation | 1 | 1.6% | |
| Dash_Punctuation | 1 | 1.6% | |
| Space_Separator | 1 | 1.6% |
| Value | Count | Frequency (%) | |
| Latin | 44 | 71.0% | |
| Common | 18 | 29.0% |
| Value | Count | Frequency (%) | |
| ASCII | 62 | 100.0% |
| Distinct count | 213342 |
|---|---|
| Unique (%) | 21.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| 11/08/2021 12:00:00 AM | 2599 |
|---|---|
| 01/31/2021 12:00:00 AM | 2575 |
| 02/06/2021 12:00:00 AM | 2430 |
| 12/02/2021 12:00:00 AM | 2139 |
| 11/17/2021 12:00:00 AM | 2052 |
| Other values (213337) |
| Value | Count | Frequency (%) | |
| 11/08/2021 12:00:00 AM | 2599 | 0.3% | |
| 01/31/2021 12:00:00 AM | 2575 | 0.3% | |
| 02/06/2021 12:00:00 AM | 2430 | 0.2% | |
| 12/02/2021 12:00:00 AM | 2139 | 0.2% | |
| 11/17/2021 12:00:00 AM | 2052 | 0.2% | |
| 12/01/2021 12:00:00 AM | 1967 | 0.2% | |
| 02/04/2021 12:00:00 AM | 1952 | 0.2% | |
| 11/03/2021 12:00:00 AM | 1917 | 0.2% | |
| 11/30/2021 12:00:00 AM | 1867 | 0.2% | |
| 02/07/2021 12:00:00 AM | 1852 | 0.2% | |
| Other values (213332) | 992636 | 97.9% |
Length
| Max length | 22 |
|---|---|
| Mean length | 22 |
| Min length | 22 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 62.5% | |
| Uppercase_Letter | 3 | 18.8% | |
| Other_Punctuation | 2 | 12.5% | |
| Space_Separator | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| Common | 13 | 81.2% | |
| Latin | 3 | 18.8% |
| Value | Count | Frequency (%) | |
| ASCII | 16 | 100.0% |
| Distinct count | 71 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 7.7 MiB |
| 12 MANHATTAN | 59424 |
|---|---|
| 07 BRONX | 52942 |
| 05 BRONX | 49353 |
| 04 BRONX | 49142 |
| 17 BROOKLYN | 36040 |
| Other values (66) |
| Value | Count | Frequency (%) | |
| 12 MANHATTAN | 59424 | 5.9% | |
| 07 BRONX | 52942 | 5.2% | |
| 05 BRONX | 49353 | 4.9% | |
| 04 BRONX | 49142 | 4.8% | |
| 17 BROOKLYN | 36040 | 3.6% | |
| 14 BROOKLYN | 35505 | 3.5% | |
| 10 MANHATTAN | 33296 | 3.3% | |
| 09 BRONX | 33144 | 3.3% | |
| 09 BROOKLYN | 29580 | 2.9% | |
| 09 MANHATTAN | 29142 | 2.9% | |
| Other values (61) | 606415 | 59.8% |
Length
| Max length | 25 |
|---|---|
| Mean length | 10.17407538 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 18 | 47.4% | |
| Decimal_Number | 10 | 26.3% | |
| Lowercase_Letter | 9 | 23.7% | |
| Space_Separator | 1 | 2.6% |
| Value | Count | Frequency (%) | |
| Latin | 27 | 71.1% | |
| Common | 11 | 28.9% |
| Value | Count | Frequency (%) | |
| ASCII | 38 | 100.0% |
| Distinct count | 73801 |
|---|---|
| Unique (%) | 7.4% |
| Missing | 10690 |
| Missing (%) | 1.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2410982162.161106 |
|---|---|
| Minimum | 0.0 |
| Maximum | 5080470023.0 |
| Zeros | 55 |
| Zeros (%) | < 0.1% |
| Memory size | 7.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1011950018 |
| Q1 | 2024650001 |
| median | 2042380027 |
| Q3 | 3051050043 |
| 95-th percentile | 4091940007 |
| Maximum | 5080470023 |
| Range | 5080470023 |
| Interquartile range (IQR) | 1026400042 |
Descriptive statistics
| Standard deviation | 1014767451 |
|---|---|
| Coefficient of variation (CV) | 0.4208938029 |
| Kurtosis | -0.788163981 |
| Mean | 2410982162 |
| Median Absolute Deviation (MAD) | 1006420007 |
| Skewness | 0.222454617 |
| Sum | 2.418928759e+15 |
| Variance | 1.029752979e+18 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 4015110001 | 9448 | 0.9% | |
| 2031430130 | 8133 | 0.8% | |
| 3061207502 | 4773 | 0.5% | |
| 2042850005 | 3964 | 0.4% | |
| 2039447501 | 3784 | 0.4% | |
| 3016910012 | 3165 | 0.3% | |
| 2025370047 | 3066 | 0.3% | |
| 3087640010 | 2470 | 0.2% | |
| 2033040010 | 2462 | 0.2% | |
| 2037140054 | 2301 | 0.2% | |
| Other values (73791) | 959730 | 94.6% | |
| (Missing) | 10690 | 1.1% |
| Value | Count | Frequency (%) | |
| 0 | 55 | < 0.1% | |
| 1000020001 | 1 | < 0.1% | |
| 1000070038 | 1 | < 0.1% | |
| 1000077501 | 5 | < 0.1% | |
| 1000110001 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5080470023 | 1 | < 0.1% | |
| 5080460052 | 2 | < 0.1% | |
| 5080450006 | 5 | < 0.1% | |
| 5080390006 | 1 | < 0.1% | |
| 5080370061 | 1 | < 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 7.7 MiB |
| BRONX | |
|---|---|
| BROOKLYN | |
| MANHATTAN | |
| QUEENS | |
| STATEN ISLAND | 10385 |
| Value | Count | Frequency (%) | |
| BRONX | 339152 | 33.4% | |
| BROOKLYN | 302875 | 29.9% | |
| MANHATTAN | 224734 | 22.2% | |
| QUEENS | 136834 | 13.5% | |
| STATEN ISLAND | 10385 | 1.0% | |
| Unspecified | 3 | < 0.1% | |
| (Missing) | 3 | < 0.1% |
Length
| Max length | 13 |
|---|---|
| Mean length | 6.99952169 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 18 | 64.3% | |
| Lowercase_Letter | 9 | 32.1% | |
| Space_Separator | 1 | 3.6% |
| Value | Count | Frequency (%) | |
| Latin | 27 | 96.4% | |
| Common | 1 | 3.6% |
| Value | Count | Frequency (%) | |
| ASCII | 28 | 100.0% |
| Distinct count | 47269 |
|---|---|
| Unique (%) | 4.7% |
| Missing | 7043 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1006545.3696038405 |
|---|---|
| Minimum | 914556.0 |
| Maximum | 1067122.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.7 MiB |
Quantile statistics
| Minimum | 914556 |
|---|---|
| 5-th percentile | 984760 |
| Q1 | 997353 |
| median | 1005750 |
| Q3 | 1015162 |
| 95-th percentile | 1032631 |
| Maximum | 1067122 |
| Range | 152566 |
| Interquartile range (IQR) | 17809 |
Descriptive statistics
| Standard deviation | 15122.62567 |
|---|---|
| Coefficient of variation (CV) | 0.01502428617 |
| Kurtosis | 2.011595376 |
| Mean | 1006545.37 |
| Median Absolute Deviation (MAD) | 8731 |
| Skewness | 0.1128997854 |
| Sum | 1.013533814e+12 |
| Variance | 228693807.2 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1018372 | 9440 | 0.9% | |
| 1012350 | 8134 | 0.8% | |
| 973626 | 4773 | 0.5% | |
| 1021173 | 3964 | 0.4% | |
| 1005083 | 3078 | 0.3% | |
| 1003545 | 2848 | 0.3% | |
| 996391 | 2354 | 0.2% | |
| 1023616 | 2325 | 0.2% | |
| 1013537 | 2322 | 0.2% | |
| 1013908 | 2297 | 0.2% | |
| Other values (47259) | 965408 | 95.2% | |
| (Missing) | 7043 | 0.7% |
| Value | Count | Frequency (%) | |
| 914556 | 1 | < 0.1% | |
| 914756 | 13 | < 0.1% | |
| 914811 | 1 | < 0.1% | |
| 914970 | 1 | < 0.1% | |
| 915001 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1067122 | 2 | < 0.1% | |
| 1067100 | 3 | < 0.1% | |
| 1067099 | 1 | < 0.1% | |
| 1067060 | 4 | < 0.1% | |
| 1067046 | 2 | < 0.1% |
| Distinct count | 58007 |
|---|---|
| Unique (%) | 5.8% |
| Missing | 7043 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 216783.51011030417 |
|---|---|
| Minimum | 122081.0 |
| Maximum | 271639.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.7 MiB |
Quantile statistics
| Minimum | 122081 |
|---|---|
| 5-th percentile | 163174 |
| Q1 | 185589.5 |
| median | 222226 |
| Q3 | 246572 |
| 95-th percentile | 258290 |
| Maximum | 271639 |
| Range | 149558 |
| Interquartile range (IQR) | 60982.5 |
Descriptive statistics
| Standard deviation | 32688.64739 |
|---|---|
| Coefficient of variation (CV) | 0.150789363 |
| Kurtosis | -1.294529913 |
| Mean | 216783.5101 |
| Median Absolute Deviation (MAD) | 27820 |
| Skewness | -0.3071329701 |
| Sum | 2.18288638e+11 |
| Variance | 1068547668 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 211606 | 9435 | 0.9% | |
| 250589 | 8134 | 0.8% | |
| 163839 | 4773 | 0.5% | |
| 249273 | 3964 | 0.4% | |
| 246580 | 3069 | 0.3% | |
| 186786 | 2791 | 0.3% | |
| 152155 | 2354 | 0.2% | |
| 254950 | 2331 | 0.2% | |
| 246058 | 2320 | 0.2% | |
| 239723 | 2299 | 0.2% | |
| Other values (57997) | 965473 | 95.2% | |
| (Missing) | 7043 | 0.7% |
| Value | Count | Frequency (%) | |
| 122081 | 7 | < 0.1% | |
| 122175 | 2 | < 0.1% | |
| 122507 | 1 | < 0.1% | |
| 122518 | 1 | < 0.1% | |
| 122953 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 271639 | 2 | < 0.1% | |
| 271583 | 1 | < 0.1% | |
| 271409 | 1 | < 0.1% | |
| 271328 | 1 | < 0.1% | |
| 271250 | 2 | < 0.1% |
Open Data Channel Type
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| PHONE | |
|---|---|
| ONLINE | |
| MOBILE |
| Value | Count | Frequency (%) | |
| PHONE | 521227 | 51.4% | |
| ONLINE | 320033 | 31.6% | |
| MOBILE | 172726 | 17.0% |
Length
| Max length | 6 |
|---|---|
| Mean length | 5.485962331 |
| Min length | 5 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 9 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
| Unspecified |
|---|
| Value | Count | Frequency (%) | |
| Unspecified | 1013986 | 100.0% |
Length
| Max length | 11 |
|---|---|
| Mean length | 11 |
| Min length | 11 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 8 | 88.9% | |
| Uppercase_Letter | 1 | 11.1% |
| Value | Count | Frequency (%) | |
| Latin | 9 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 9 | 100.0% |
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 7.7 MiB |
| BRONX | |
|---|---|
| BROOKLYN | |
| MANHATTAN | |
| QUEENS | |
| STATEN ISLAND | 10385 |
| Value | Count | Frequency (%) | |
| BRONX | 339152 | 33.4% | |
| BROOKLYN | 302875 | 29.9% | |
| MANHATTAN | 224734 | 22.2% | |
| QUEENS | 136834 | 13.5% | |
| STATEN ISLAND | 10385 | 1.0% | |
| Unspecified | 3 | < 0.1% | |
| (Missing) | 3 | < 0.1% |
Length
| Max length | 13 |
|---|---|
| Mean length | 6.99952169 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 18 | 64.3% | |
| Lowercase_Letter | 9 | 32.1% | |
| Space_Separator | 1 | 3.6% |
| Value | Count | Frequency (%) | |
| Latin | 27 | 96.4% | |
| Common | 1 | 3.6% |
| Value | Count | Frequency (%) | |
| ASCII | 28 | 100.0% |
| Distinct count | 85329 |
|---|---|
| Unique (%) | 8.5% |
| Missing | 7043 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.76165547838995 |
|---|---|
| Minimum | 40.50150695570338 |
| Maximum | 40.91221758090332 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.7 MiB |
Quantile statistics
| Minimum | 40.50150696 |
|---|---|
| 5-th percentile | 40.61454225 |
| Q1 | 40.67603145 |
| median | 40.77662647 |
| Q3 | 40.84342648 |
| 95-th percentile | 40.87556453 |
| Maximum | 40.91221758 |
| Range | 0.4107106252 |
| Interquartile range (IQR) | 0.1673950244 |
Descriptive statistics
| Standard deviation | 0.08971736958 |
|---|---|
| Coefficient of variation (CV) | 0.002201023696 |
| Kurtosis | -1.294606905 |
| Mean | 40.76165548 |
| Median Absolute Deviation (MAD) | 0.07633946117 |
| Skewness | -0.3071820114 |
| Sum | 41044663.65 |
| Variance | 0.008049206405 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 40.74742033 | 9410 | 0.9% | |
| 40.8544391 | 8133 | 0.8% | |
| 40.61637027 | 4773 | 0.5% | |
| 40.85079459 | 3964 | 0.4% | |
| 40.84345572 | 3066 | 0.3% | |
| 40.67934016 | 2790 | 0.3% | |
| 40.58429811 | 2354 | 0.2% | |
| 40.86640487 | 2321 | 0.2% | |
| 40.84195982 | 2313 | 0.2% | |
| 40.82459453 | 2295 | 0.2% | |
| Other values (85319) | 965524 | 95.2% | |
| (Missing) | 7043 | 0.7% |
| Value | Count | Frequency (%) | |
| 40.50150696 | 7 | < 0.1% | |
| 40.5017699 | 2 | < 0.1% | |
| 40.5026674 | 1 | < 0.1% | |
| 40.5027036 | 1 | < 0.1% | |
| 40.50389674 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 40.91221758 | 2 | < 0.1% | |
| 40.91206287 | 1 | < 0.1% | |
| 40.91158732 | 1 | < 0.1% | |
| 40.91136264 | 1 | < 0.1% | |
| 40.91114555 | 2 | < 0.1% |
| Distinct count | 85329 |
|---|---|
| Unique (%) | 8.5% |
| Missing | 7043 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.91949324785969 |
|---|---|
| Minimum | -74.25064221795266 |
| Maximum | -73.70093754842728 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.7 MiB |
Quantile statistics
| Minimum | -74.25064222 |
|---|---|
| 5-th percentile | -73.99816189 |
| Q1 | -73.95274327 |
| median | -73.92238083 |
| Q3 | -73.88835247 |
| 95-th percentile | -73.82536934 |
| Maximum | -73.70093755 |
| Range | 0.5497046695 |
| Interquartile range (IQR) | 0.06439079828 |
Descriptive statistics
| Standard deviation | 0.05457925523 |
|---|---|
| Coefficient of variation (CV) | -0.0007383607873 |
| Kurtosis | 1.988998837 |
| Mean | -73.91949325 |
| Median Absolute Deviation (MAD) | 0.03155598175 |
| Skewness | 0.1106265704 |
| Sum | -74432716.29 |
| Variance | 0.002978895101 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| -73.87685301 | 9410 | 0.9% | |
| -73.89842337 | 8133 | 0.8% | |
| -74.03826694 | 4773 | 0.5% | |
| -73.86653704 | 3964 | 0.4% | |
| -73.92470475 | 3066 | 0.3% | |
| -73.93043506 | 2790 | 0.3% | |
| -73.95628992 | 2354 | 0.2% | |
| -73.89411351 | 2321 | 0.2% | |
| -73.85772539 | 2313 | 0.2% | |
| -73.87729914 | 2295 | 0.2% | |
| Other values (85319) | 965524 | 95.2% | |
| (Missing) | 7043 | 0.7% |
| Value | Count | Frequency (%) | |
| -74.25064222 | 1 | < 0.1% | |
| -74.24992323 | 13 | < 0.1% | |
| -74.24972456 | 1 | < 0.1% | |
| -74.24915576 | 1 | < 0.1% | |
| -74.2490386 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| -73.70093755 | 2 | < 0.1% | |
| -73.7010117 | 3 | < 0.1% | |
| -73.70101524 | 1 | < 0.1% | |
| -73.70115242 | 3 | < 0.1% | |
| -73.70115317 | 1 | < 0.1% |
| Distinct count | 85329 |
|---|---|
| Unique (%) | 8.5% |
| Missing | 7043 |
| Missing (%) | 0.7% |
| Memory size | 7.7 MiB |
| (40.747420328856705, -73.87685300997468) | 9410 |
|---|---|
| (40.85443910241399, -73.8984233658015) | 8133 |
| (40.61637026983262, -74.03826694457253) | 4773 |
| (40.850794587937656, -73.86653703997725) | 3964 |
| (40.84345572380287, -73.92470475387987) | 3066 |
| Other values (85324) |
| Value | Count | Frequency (%) | |
| (40.747420328856705, -73.87685300997468) | 9410 | 0.9% | |
| (40.85443910241399, -73.8984233658015) | 8133 | 0.8% | |
| (40.61637026983262, -74.03826694457253) | 4773 | 0.5% | |
| (40.850794587937656, -73.86653703997725) | 3964 | 0.4% | |
| (40.84345572380287, -73.92470475387987) | 3066 | 0.3% | |
| (40.67934015517145, -73.93043505876992) | 2790 | 0.3% | |
| (40.58429811390181, -73.95628992267918) | 2354 | 0.2% | |
| (40.86640486876999, -73.89411351479727) | 2321 | 0.2% | |
| (40.84195981610547, -73.85772539024822) | 2313 | 0.2% | |
| (40.824594531459304, -73.8772991398564) | 2295 | 0.2% | |
| Other values (85319) | 965524 | 95.2% | |
| (Missing) | 7043 | 0.7% |
Length
| Max length | 40 |
|---|---|
| Mean length | 38.80981296 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 55.6% | |
| Other_Punctuation | 2 | 11.1% | |
| Lowercase_Letter | 2 | 11.1% | |
| Close_Punctuation | 1 | 5.6% | |
| Open_Punctuation | 1 | 5.6% | |
| Space_Separator | 1 | 5.6% | |
| Dash_Punctuation | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| Common | 16 | 88.9% | |
| Latin | 2 | 11.1% |
| Value | Count | Frequency (%) | |
| ASCII | 18 | 100.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Unique Key | Created Date | Closed Date | Agency | Agency Name | Complaint Type | Descriptor | Location Type | Incident Zip | Incident Address | Street Name | Cross Street 1 | Cross Street 2 | Intersection Street 1 | Intersection Street 2 | Address Type | City | Landmark | Facility Type | Status | Due Date | Resolution Description | Resolution Action Updated Date | Community Board | BBL | Borough | X Coordinate (State Plane) | Y Coordinate (State Plane) | Open Data Channel Type | Park Facility Name | Park Borough | Vehicle Type | Taxi Company Borough | Taxi Pick Up Location | Bridge Highway Name | Bridge Highway Direction | Road Ramp | Bridge Highway Segment | Latitude | Longitude | Location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 37666285 | 11/12/2017 12:00:00 AM | 01/22/2018 12:00:00 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | APARTMENT ONLY | RESIDENTIAL BUILDING | 10034.0 | 165 SHERMAN AVENUE | SHERMAN AVENUE | NaN | NaN | NaN | NaN | ADDRESS | NEW YORK | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists. | 01/22/2018 12:00:00 AM | 12 MANHATTAN | 1.022210e+09 | MANHATTAN | 1005613.0 | 254344.0 | PHONE | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.864764 | -73.922764 | (40.86476431663921, -73.92276447154296) |
| 1 | 37675276 | 11/12/2017 12:00:00 AM | 04/08/2019 12:00:00 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | APARTMENT ONLY | RESIDENTIAL BUILDING | 10454.0 | 353 EAST 141 STREET | EAST 141 STREET | NaN | NaN | NaN | NaN | ADDRESS | BRONX | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists. | 04/08/2019 12:00:00 AM | 01 BRONX | 2.023040e+09 | BRONX | 1005674.0 | 234944.0 | ONLINE | Unspecified | BRONX | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.811517 | -73.922606 | (40.81151682281859, -73.92260590193087) |
| 2 | 37682385 | 11/13/2017 12:00:00 AM | 11/13/2017 12:00:00 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 11238.0 | 374 PROSPECT PLACE | PROSPECT PLACE | NaN | NaN | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists. | 11/13/2017 12:00:00 AM | 08 BROOKLYN | 3.011600e+09 | BROOKLYN | 994136.0 | 185823.0 | ONLINE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.676712 | -73.964359 | (40.67671244686174, -73.96435906406927) |
| 3 | 38112583 | 01/04/2018 12:00:00 AM | 03/18/2018 12:00:00 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 10031.0 | 38 ST NICHOLAS PLACE | ST NICHOLAS PLACE | NaN | NaN | NaN | NaN | ADDRESS | NEW YORK | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists. | 03/18/2018 12:00:00 AM | 09 MANHATTAN | 1.020540e+09 | MANHATTAN | 1000450.0 | 241141.0 | PHONE | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.828537 | -73.941463 | (40.82853696054143, -73.94146261055029) |
| 4 | 38792282 | 03/27/2018 12:00:00 AM | 03/28/2018 12:00:00 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 11216.0 | 159 HALSEY STREET | HALSEY STREET | NaN | NaN | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists. | 03/28/2018 12:00:00 AM | 03 BROOKLYN | 3.018380e+09 | BROOKLYN | 998843.0 | 187787.0 | PHONE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.682097 | -73.947385 | (40.68209667277928, -73.9473851721007) |
| 5 | 38793312 | 03/27/2018 12:00:00 AM | 03/30/2018 12:00:00 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 11203.0 | 374 EAST 49 STREET | EAST 49 STREET | NaN | NaN | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists. | 03/30/2018 12:00:00 AM | 17 BROOKLYN | 3.046740e+09 | BROOKLYN | 1003252.0 | 177119.0 | ONLINE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.652807 | -73.931519 | (40.65280703038938, -73.9315186685526) |
| 6 | 38799862 | 03/27/2018 12:00:00 AM | 04/04/2018 12:00:00 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 10034.0 | 165 SHERMAN AVENUE | SHERMAN AVENUE | NaN | NaN | NaN | NaN | ADDRESS | NEW YORK | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists. | 04/04/2018 12:00:00 AM | 12 MANHATTAN | 1.022210e+09 | MANHATTAN | 1005613.0 | 254344.0 | PHONE | Unspecified | MANHATTAN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.864764 | -73.922764 | (40.86476431663921, -73.92276447154296) |
| 7 | 36871751 | 08/04/2017 02:26:11 AM | 08/05/2017 02:46:11 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 11201.0 | 284 ATLANTIC AVENUE | ATLANTIC AVENUE | NaN | NaN | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development has closed this complaint administratively. More information can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option. | 08/05/2017 02:46:11 AM | 02 BROOKLYN | 3.001810e+09 | BROOKLYN | 987141.0 | 190205.0 | ONLINE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.688745 | -73.989576 | (40.68874508704761, -73.98957550708268) |
| 8 | 36949988 | 08/15/2017 08:04:39 AM | 08/17/2017 02:06:36 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | APARTMENT ONLY | RESIDENTIAL BUILDING | 11206.0 | 417 LORIMER STREET | LORIMER STREET | NaN | NaN | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | NaN | The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. | 08/17/2017 02:06:36 AM | 01 BROOKLYN | 3.030220e+09 | BROOKLYN | 998497.0 | 197731.0 | MOBILE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.709391 | -73.948612 | (40.70939120268948, -73.94861163637752) |
| 9 | 36951576 | 08/15/2017 07:12:41 PM | 08/18/2017 02:14:04 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 11238.0 | 575 GRAND AVENUE | GRAND AVENUE | NaN | NaN | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development was not able to gain access to your apartment or others in the building to inspect for a lack of heat or hot water. The complaint has been closed. If the condition still exists, please file a new complaint. | 08/18/2017 02:14:04 AM | 08 BROOKLYN | 3.011480e+09 | BROOKLYN | 994712.0 | 186288.0 | PHONE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.677988 | -73.962282 | (40.67798810469399, -73.96228175142863) |
Last rows
| Unique Key | Created Date | Closed Date | Agency | Agency Name | Complaint Type | Descriptor | Location Type | Incident Zip | Incident Address | Street Name | Cross Street 1 | Cross Street 2 | Intersection Street 1 | Intersection Street 2 | Address Type | City | Landmark | Facility Type | Status | Due Date | Resolution Description | Resolution Action Updated Date | Community Board | BBL | Borough | X Coordinate (State Plane) | Y Coordinate (State Plane) | Open Data Channel Type | Park Facility Name | Park Borough | Vehicle Type | Taxi Company Borough | Taxi Pick Up Location | Bridge Highway Name | Bridge Highway Direction | Road Ramp | Bridge Highway Segment | Latitude | Longitude | Location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1013976 | 42053310 | 03/25/2019 11:07:02 AM | 03/27/2019 07:29:23 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 11233.0 | 205 SUMPTER STREET | SUMPTER STREET | NaN | NaN | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed. | 03/27/2019 07:29:23 AM | 03 BROOKLYN | 3.015190e+09 | BROOKLYN | 1007129.0 | 187133.0 | PHONE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.680284 | -73.917512 | (40.680284053302664, -73.9175123666471) |
| 1013977 | 42053306 | 03/25/2019 09:45:28 AM | 03/27/2019 11:58:16 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 11230.0 | 1585 EAST 14 STREET | EAST 14 STREET | NaN | NaN | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint. | 03/27/2019 11:58:16 AM | 14 BROOKLYN | 3.067610e+09 | BROOKLYN | 995459.0 | 161861.0 | PHONE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.610940 | -73.959629 | (40.61094034785047, -73.95962920796566) |
| 1013978 | 42053286 | 03/25/2019 09:05:45 PM | 03/27/2019 02:07:47 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 10452.0 | 1425 DR M L KING JR BOULEVARD | DR M L KING JR BOULEVARD | NaN | NaN | NaN | NaN | ADDRESS | BRONX | NaN | NaN | Closed | NaN | The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. | 03/27/2019 02:07:47 AM | 04 BRONX | 2.025370e+09 | BRONX | 1005083.0 | 246580.0 | MOBILE | Unspecified | BRONX | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.843456 | -73.924705 | (40.84345572380287, -73.92470475387987) |
| 1013979 | 42053318 | 03/25/2019 09:21:58 PM | 03/27/2019 08:34:59 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 10456.0 | 3475 3 AVENUE | 3 AVENUE | NaN | NaN | NaN | NaN | ADDRESS | BRONX | NaN | NaN | Closed | NaN | The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. | 03/27/2019 08:34:59 AM | 03 BRONX | 2.023720e+09 | BRONX | 1010177.0 | 241700.0 | PHONE | Unspecified | BRONX | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.830048 | -73.906313 | (40.83004805755818, -73.90631274439146) |
| 1013980 | 42053287 | 03/25/2019 08:46:38 AM | 03/27/2019 05:27:21 PM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 10458.0 | 2968 PERRY AVENUE | PERRY AVENUE | NaN | NaN | NaN | NaN | ADDRESS | BRONX | NaN | NaN | Closed | NaN | The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. | 03/27/2019 05:27:21 PM | 07 BRONX | 2.032920e+09 | BRONX | 1016331.0 | 256308.0 | PHONE | Unspecified | BRONX | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.870122 | -73.884005 | (40.87012244969979, -73.88400538088398) |
| 1013981 | 42053304 | 03/25/2019 04:44:13 PM | 03/27/2019 08:52:07 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 10469.0 | 3478 FENTON AVENUE | FENTON AVENUE | NaN | NaN | NaN | NaN | ADDRESS | BRONX | NaN | NaN | Closed | NaN | The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. | 03/27/2019 08:52:07 AM | 12 BRONX | 2.047210e+09 | BRONX | 1026044.0 | 259103.0 | MOBILE | Unspecified | BRONX | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.877753 | -73.848869 | (40.87775320807253, -73.84886891043506) |
| 1013982 | 42053317 | 03/25/2019 02:45:10 PM | 03/27/2019 04:56:33 PM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 10462.0 | 2132 WALLACE AVENUE | WALLACE AVENUE | NaN | NaN | NaN | NaN | ADDRESS | BRONX | NaN | NaN | Closed | NaN | The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. | 03/27/2019 04:56:33 PM | 11 BRONX | 2.042920e+09 | BRONX | 1021647.0 | 250439.0 | PHONE | Unspecified | BRONX | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.853993 | -73.864817 | (40.85399291289473, -73.86481720417432) |
| 1013983 | 42053292 | 03/25/2019 06:27:04 AM | 03/25/2019 09:14:17 PM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 11225.0 | 486 BROOKLYN AVENUE | BROOKLYN AVENUE | NaN | NaN | NaN | NaN | ADDRESS | BROOKLYN | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option. | 03/25/2019 09:14:17 PM | 09 BROOKLYN | 3.013220e+09 | BROOKLYN | 999344.0 | 180820.0 | PHONE | Unspecified | BROOKLYN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.662973 | -73.945594 | (40.66297298421168, -73.94559442643347) |
| 1013984 | 42053305 | 03/25/2019 07:35:11 PM | 03/27/2019 02:07:56 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 10461.0 | 2935 WILKINSON AVENUE | WILKINSON AVENUE | NaN | NaN | NaN | NaN | ADDRESS | BRONX | NaN | NaN | Closed | NaN | The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification. | 03/27/2019 02:07:56 AM | 10 BRONX | 2.042450e+09 | BRONX | 1031086.0 | 249612.0 | ONLINE | Unspecified | BRONX | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.851678 | -73.830703 | (40.85167802151147, -73.83070293065111) |
| 1013985 | 42053288 | 03/25/2019 10:32:09 PM | 03/28/2019 02:07:44 AM | HPD | Department of Housing Preservation and Development | HEAT/HOT WATER | ENTIRE BUILDING | RESIDENTIAL BUILDING | 10463.0 | 2834 HEATH AVENUE | HEATH AVENUE | NaN | NaN | NaN | NaN | ADDRESS | BRONX | NaN | NaN | Closed | NaN | The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint. | 03/28/2019 02:07:44 AM | 08 BRONX | 2.032560e+09 | BRONX | 1010780.0 | 257535.0 | ONLINE | Unspecified | BRONX | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40.873509 | -73.904071 | (40.87350861612905, -73.90407114254262) |